Stored Procedures [dbo].[BAEBillingSetupUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ProductCodevarchar(256)256
@Titlevarchar(256)256
@Descriptionvarchar(256)256
@OrderProductCodevarchar(256)256
@MemberTypesvarchar(256)256
SQL Script
create procedure [dbo].[BAEBillingSetupUpdate] @ProductCode as
varchar(256),    
    @Title AS varchar(256),    
    @Description AS varchar(256),    
    @OrderProductCode AS varchar(256),    
    @MemberTypes AS varchar(256)
AS
    UPDATE BillingSetup
    SET
        Title = @Title,
        Description = @Description,
        OrderProductCode = @OrderProductCode,
        MemberTypes = @MemberTypes
    WHERE ProductCode = @ProductCode;

GO
Uses